package com.myteam.mystory.DAO;

import android.database.sqlite.SQLiteDatabase;

public class StoriesScheme {
	public static final String TABLE_STORY_NAME = "stories";
	public static final String STORYID = "storyId";
	public static final String CATEID = "cateID";
	public static final String NAME = "name";
	public static final String ACODE = "acode";
	public static final String IMGLINK = "imglink";
	public static final String DESCRIPTION = "description";
	public static final String BOOKMARK = "bookmark";
	public static final String HISTORY = "history";
	public static final String VIEWCOUNT = "viewCount";
	public static final String LIKECOUNT = "likeCount";
	public static final String STATUT = "statut";

	private static final String DATEBASE_CREATE_STORY = "create table "
			+ TABLE_STORY_NAME + "(" + STORYID + " text primary key, " + CATEID
			+ " text not null, " + NAME + " text not null, " + ACODE
			+ " text not null, " + IMGLINK + " text not null, " + DESCRIPTION
			+ " text not null, " + BOOKMARK + " interger not null, " + HISTORY
			+ " interger not null, " + VIEWCOUNT + " interger not null, "
			+ LIKECOUNT + " interger not null, " + STATUT + " text not null)";

	public static void onCreate(SQLiteDatabase db) {
		db.execSQL(DATEBASE_CREATE_STORY);
	}
}
